Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# recordSpec

Syntax

recordSpec::=

Description of the illustration recordspec.gif

Purpose

A subclause that specifies which objects the CHANGE, CROSSCHECK, DELETE, and LIST commands should operate on.

Most `recordSpec` options allow you to specify a primary key. Use the output of the `LIST` command to obtain keys.

Keywords and Parameters

Syntax Element | Description
--- | ---
`ARCHIVELOG` | Specifies an archived redo log by either `primary_key` or `'``filename``'`.
`BACKUPSET` `primary_key` | Specifies a backup set by `primary_key`.
`BACKUPPIECE` | Specifies a backup piece by `'``media_handle``'`, `primary_key`, or `tag_name`.
`PROXY` | Specifies a proxy copy by `'``media_handle``'`, `primary_key`, or `tag_name`.
`CONTROLFILECOPY` | Specifies a control file copy by `primary_key`, filename pattern (`'filename'`), or `TAG` `=` `tag_name`. If you crosscheck a control file copy, you must specify a filename rather than a primary key.
`DATAFILECOPY` | Specifies a datafile copy by either `primary_key`, filename pattern (`'filename'`), or `TAG` `=` `tag_name`.
`NODUPLICATES` | With `CONTROLFILECOPY` or `DATAFILECOPY`, specifies that only one copy of the control file or datafile copy specified by the rest of the clause should be the target of the operation, even when there are multiple copies.

Examples

Crosschecking Backups: Example This example crosschecks backup sets specified by primary key:

    CROSSCHECK BACKUPSET 507, 509;

Deleting Datafile Copies: Example This example deletes a specified datafile copy:

    DELETE NOPROMPT DATAFILECOPY '?/oradata/users01.cpy';